package com.zhongyu.mapper;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.zhongyu.pojo.GoodsType;
import com.zhongyu.pojo.Provider;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ProviderMapper extends BaseMapper<Provider> {

    @Select("select * from smbms_Provider ${ew.customSqlSegment}")
    List<Provider> findAll(Page page , @Param("ew") Wrapper wrapper);

    @Select("select pro_Name from smbms_Provider where id=#{providerId}")
    String findById(Integer providerId);
}
